|
7 Search Results Found |
1 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 16 October 2008 10:34 «»
By: shashish
How To identify the tables from a dblinks seeing at a procedure
…
PROCEDURE import
IS
vBeginTime DATE := SYSDATE;
vStartTime DATE;
my_last_update DATE;
BEGIN
SELECT lastrefresh INTO my_last_update
FROM RefreshSem;
DBMS_OUTPUT.PUT_LINE('RefreshSem…
|
2 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 10 November 2005 01:25 «»
By: tarundua
Re: time variant tables
Sumeet,
please read the sticky,
http://www.orafaq.com/forum/t/42427/72347/
No sample input, no sample output. people keep guessing.
|
3 |
Forum: Training & Certification «»
Posted on: Sat, 26 June 2004 04:51 «»
By: sumeet
Re: Interview Questions(SQL, PL/SQL, SQL Plus, Developer, Database, anything dealing with Oracle)
hi this is sumeet, i need to study sinterview questions since i am scheduled attend an interview in oracle, so pls do the needful on platforms : sql,pl/sql, developer all the above in 9i.
thanks, sumeet.
|
4 |
Forum: Training & Certification «»
Posted on: Sat, 26 June 2004 04:48 «»
By: sumeet
Re: Interview Questions in oracle d2k
hi this is sumeet,
i need to study some interview questions on forms6i,
so could u do the needful.
thanks
|
5 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 19 June 2003 06:19 «»
By: sumeet
Group by Query
…have a table TAB_A and a table TAB_B.
I want to update a field in table TAB_A by comparing a field of it with a field in table TAB_B, and also by putting a group by condition. The query I want to write is something like this:
UPDATE TAB_A
SET FLAG = 'n…
|
6 |
Forum: Server Utilities «»
Posted on: Wed, 08 November 2000 08:33 «»
By: Bala
Re: SQL*Loader and Seamless login
…
On a user by user basis, you can use OS or External
authentication. For example, you can setup OS_AUTHENT_PREFIX in
your init.ora to be "ops$". You have a Unix account "sumeet". you can
created a database user:
SQL> create …
|
7 |
Forum: Server Utilities «»
Posted on: Mon, 06 November 2000 15:42 «»
By: Vinay Sahitya
SQL*Loader and Seamless login
…command for sqlldr is userid=aaa/bbb control=xxx.ctl and requires password to be given. However for security reasons our company prohibits hardcoding passwords anywhere in a readable format. Is there a way on unix to get the password from environment or …
|